SchoolStatus 
EntityType  Independent 
Logical Entity Name  SchoolStatus 
Default Table Name  SySchoolStatus 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

SchoolStatus Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
SchoolStatusId(PK)    INTEGER  NO 
 
Code    CHAR(8)  NO 
 
Name    VARCHAR(35)  NO 
 
CampusGroupId    INTEGER  NO 
 
SystemSchoolStatusId    INTEGER  NO 
 
IsSystemCode    BIT  NO 
 
IsActive    BIT  NO 
 
ModFlag    CHAR(1)  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
NSLDSStatus    CHAR(1)  YES 
 
IsExcludedCrmIntegration    BIT  NO 
 

SchoolStatus Keys 
Key Name  Key Type  Keys 
SySchoolStatus_SyCampusGrpID_N_N_IDX  Inversion Entry  CampusGroupId 
SySchoolStatus_SySchoolStatusID_U_C_IDX  PrimaryKey  SchoolStatusId 
SySchoolStatus_SyStatusID_N_N_IDX  Inversion Entry  SystemSchoolStatusId 

SchoolStatus Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
SchoolStatusChangeReason  Non-Specific            NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
JobType  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
AdEnrollTermRelationshipException  Non-Identifying  One To Zero or More          NO 
FaSapTable  Non-Identifying  One To Zero or More          NO 
DisbursementApprovalRuleSchoolStatusList  Identifying  One To Zero or More          NO 
HsRoomMateMatchStudentStatus  Non-Identifying  One To Zero or More          NO 
PlEmploymentStatusExternalMap  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummaryInSchoolDetail  Non-Identifying  One To Zero or More          NO 
SyCrmSchoolStatus  Non-Identifying  One To Zero or More          NO 
sySchoolStatusExternalMap  Non-Identifying  One To Zero or More          NO 
SySchoolStatusLanguage  Non-Identifying  One To Zero or More          NO 
StudentPlacementStatusHistory  Non-Identifying  One To Zero or More          NO 
PendingApplicantSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentPlacementStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummary  Non-Identifying  One To Zero or More          NO 
PendingApplicantSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
PlacementStatusReason  Non-Identifying  One To Zero or More          NO 
ProspectInquiry  Non-Identifying  One To Zero or More          NO 
SchoolStatusChangeReason  Non-Identifying  One To Zero or More          NO 
Student  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummaryInSchoolDetail  Non-Identifying  One To Zero or More          NO 

SchoolStatus Check Constraints 
Check Constraint Name  CheckConstraint 

SchoolStatus Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.SchoolStatus 
NO       
Physical (Microsoft SQL Server)
dbo.SySchoolStatus 
NO       

SchoolStatus Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Applicant_Enroll 
Logical  AvailableJobs 
Logical  Prospect 
Logical  StudentEnrollment 
Logical  StudentJobPlacement 
Logical  StudentPlacementPreferences 
Logical  Tasks 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 
Physical (Microsoft SQL Server)  System 

SchoolStatus Data Movement Rules 
Name  Type  Rule Text/Value